import datetime
from applications.extensions import db


class Equipment(db.Model):
    __tablename__ = 'admin_testing_equipment'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    name = db.Column(db.String(32), comment='设备名称')
    user_id = db.Column(db.Integer, comment='添加人id', default=0)
    notes = db.Column(db.Text(), comment='备注')
    enable = db.Column(db.Integer, default=0, comment='状态。1启用 0禁用')
    create_time = db.Column(db.DateTime, default=datetime.datetime.now, comment='创建时间')
    device_no = db.Column(db.String(32), comment='设备编号')
